﻿#region Usings

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using xConnected.Core.Model;

#endregion

namespace xConnected.Data
{
    public class CustomContextInitializer : DropCreateDatabaseIfModelChanges<DataContext>
    {
        protected override void Seed(DataContext context)
        {
            //var user1 = new User
            //{
            //    Email = "gorgieva.sandra123@gmail.com",
            //    Username = "sandragorg88",
            //    Password = "123456",
            //    IsActivated = true,
            //    ActivationKey = Guid.NewGuid(),
            //    MessageFolders = new List<MessageFolder> { new MessageFolder { Name = "Inbox", FolderType = 0 }, new MessageFolder { Name = "Outbox", FolderType = 1 }, new MessageFolder { Name = "Trash", FolderType = 2 }, new MessageFolder { Name = "Public", FolderType = 3 } },
            //    AccountType = 0
            //};
            //var user2 = new User
            //{
            //    Email = "gorgievasandra@yahoo.com",
            //    Username = "company",
            //    Password = "123456",
            //    IsActivated = true,
            //    ActivationKey = Guid.NewGuid(),
            //    MessageFolders = new List<MessageFolder> { new MessageFolder { Name = "Inbox", FolderType = 0 }, new MessageFolder { Name = "Outbox", FolderType = 1 }, new MessageFolder { Name = "Trash", FolderType = 2 }, new MessageFolder { Name = "Public", FolderType = 3 } },
            //    AccountType = 1
            //};
            //var user3 = new User
            //{
            //    Email = "gorgievasandra@yahoo.com",
            //    Username = "user3",
            //    Password = "123456",
            //    IsActivated = true,
            //    ActivationKey = Guid.NewGuid(),
            //    MessageFolders = new List<MessageFolder> { new MessageFolder { Name = "Inbox", FolderType = 0 }, new MessageFolder { Name = "Outbox", FolderType = 1 }, new MessageFolder { Name = "Trash", FolderType = 2 }, new MessageFolder { Name = "Public", FolderType = 3 } },
            //    AccountType = 1
            //};
            //var user4 = new User
            //{
            //    Email = "goran.jovanov@gmail.com",
            //    Username = "gjovanov",
            //    Password = "123456",
            //    IsActivated = true,
            //    ActivationKey = Guid.NewGuid(),
            //    MessageFolders = new List<MessageFolder> { new MessageFolder { Name = "Inbox", FolderType = 0 }, new MessageFolder { Name = "Outbox", FolderType = 1 }, new MessageFolder { Name = "Trash", FolderType = 2 }, new MessageFolder { Name = "Public", FolderType = 3 } },
            //    AccountType = 1
            //};
            //new List<User>
            //    {
            //        user1,
            //        user2,
            //        user3,
            //        user4
            //    }.ForEach(u => context.Users.AddOrUpdate(u));


            //// INDUSTRIES
            //var itIndustry = new Industry
            //{
            //    Key = "Industry/IT",
            //    Description = "IT",
            //};

            //var constructionIndustry = new Industry
            //{
            //    Key = "Industry/Construction",
            //    Description = "Construction",
            //};

            //var creativeIndustry = new Industry
            //{
            //    Key = "Industry/Creative",
            //    Description = "Creative",
            //};
            //new List<Industry>
            //    {
            //        itIndustry,
            //        constructionIndustry,
            //        creativeIndustry
            //    }.ForEach(i => context.Industries.AddOrUpdate(i));

            ////CATEGORIES
            //var AdministrationSupport = new Category
            //{
            //    Key = "Administration/Support",
            //    Description = "Administration/Support",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var ArchitectureDesign = new Category
            //{
            //    Key = "Architecture/Design",
            //    Description = "Architecture/Design",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var BusinessAnalysisConsulting = new Category
            //{
            //    Key = "Business analysis/Consulting",
            //    Description = "Business analysis/Consulting",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var InterdisciplinaryRoles = new Category
            //{
            //    Key = "Interdisciplinary roles",
            //    Description = "Interdisciplinary roles",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var ManagementIT = new Category
            //{
            //    Key = "Management IT",
            //    Description = "Management IT",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var Network = new Category
            //{
            //    Key = "Network",
            //    Description = "Network",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var QualityAssuranceTest = new Category
            //{
            //    Key = "Quality assurance/Test",
            //    Description = "Quality assurance/Test",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var SoftwareDevelopment = new Category
            //{
            //    Key = "Software development",
            //    Description = "Software development",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};
            //var Trainer = new Category
            //{
            //    Key = "Trainer",
            //    Description = "Trainer",
            //    ParentCategory = null,
            //    Industry = itIndustry
            //};

            ////Start->Administration/Support
            //var ApplicationConsultant = new Category
            //{
            //    Key = "Application consultant",
            //    Description = "Application consultant",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var DatabaseAdministrator = new Category

            //{
            //    Key = "Database administrator",
            //    Description = "Database administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var ITOperator = new Category
            //{
            //    Key = "IT operator",
            //    Description = "IT operator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var LinuxAdministrator = new Category
            //{
            //    Key = "Linux administrator",
            //    Description = "Linux administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var SAPAdministrator = new Category
            //{
            //    Key = "SAP administrator",
            //    Description = "SAP administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var UnixAdministrator = new Category
            //{
            //    Key = "Unix administrator",
            //    Description = "Unix administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var WindowsAdministrator = new Category
            //{
            //    Key = "Windows administrator",
            //    Description = "Windows administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var ApplicationServerAdministrator = new Category
            //{
            //    Key = "Application server administrator",
            //    Description = "Application server administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var HelpdeskSupport = new Category
            //{
            //    Key = "Helpdesk/support",
            //    Description = "Helpdesk/support",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var ITTechnician = new Category
            //{
            //    Key = "IT technician",
            //    Description = "IT technician",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var NetworkAdministrator = new Category
            //{
            //    Key = "Network administrator",
            //    Description = "Network administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var StorageAdministrator = new Category
            //{
            //    Key = "Storage administrator",
            //    Description = "Storage administrator",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};
            //var Webmaster = new Category
            //{
            //    Key = "Webmaster",
            //    Description = "Webmaster",
            //    ParentCategory = AdministrationSupport,
            //    Industry = itIndustry
            //};


            ////Start->Architecture/Design
            //var CapacityManager = new Category
            //{
            //    Key = "Capacity manager",
            //    Description = "Capacity manager",
            //    ParentCategory = ArchitectureDesign,
            //    Industry = itIndustry
            //};
            //var SystemArchitect = new Category
            //{
            //    Key = "System architect",
            //    Description = "System architect",
            //    ParentCategory = ArchitectureDesign,
            //    Industry = itIndustry
            //};
            //var SoftwareArchitect = new Category
            //{
            //    Key = "Software architect",
            //    Description = "Software architect",
            //    ParentCategory = ArchitectureDesign,
            //    Industry = itIndustry
            //};
            //var WebDesigner = new Category
            //{
            //    Key = "Web designer",
            //    Description = "Web designer",
            //    ParentCategory = ArchitectureDesign,
            //    Industry = itIndustry
            //};

            ////Start->Business analysis/Consulting
            //var BIConsultant = new Category
            //{
            //    Key = "BI consultant",
            //    Description = "BI consultant",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};
            //var ChangeManager = new Category
            //{
            //    Key = "Change manager",
            //    Description = "Change manager",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};
            //var ITConsultant = new Category
            //{
            //    Key = "IT consultant",
            //    Description = "IT consultant",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};
            //var SystemAnalyst = new Category
            //{
            //    Key = "System analyst",
            //    Description = "System analyst",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};
            //var CRMConsultant = new Category
            //{
            //    Key = "CRM consultant",
            //    Description = "CRM consultant",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};
            //var ConsultantForTradingSystems = new Category
            //{
            //    Key = "Consultant for trading systems",
            //    Description = "Consultant for trading systems",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};
            //var SAPConsultant = new Category
            //{
            //    Key = "SAP consultant",
            //    Description = "SAP consultant",
            //    ParentCategory = BusinessAnalysisConsulting,
            //    Industry = itIndustry
            //};

            ////Start-> Interdisciplinary roles
            //var Auditor = new Category
            //{
            //    Key = "Auditor",
            //    Description = "Auditor",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var BusinessDevelopmentManager = new Category
            //{
            //    Key = "Business development manager",
            //    Description = "Business development manager",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var DirectorBusinessDevelopment = new Category
            //{
            //    Key = "Director business development",
            //    Description = "Director business development",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};

            //var ProgramManager = new Category
            //{
            //    Key = "Program manager",
            //    Description = "Program manager",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var ProjectManager = new Category
            //{
            //    Key = "Position manager",
            //    Description = "Position manager",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var QualityAssuranceProfessional = new Category
            //{
            //    Key = "Quality assurance professional",
            //    Description = "Quality assurance professional",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var QualityManager = new Category
            //{
            //    Key = "Quality manager",
            //    Description = "Quality manager",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var SubprojectManager = new Category
            //{
            //    Key = "Subproject manager",
            //    Description = "Subproject manager",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var WorkPlanner = new Category
            //{
            //    Key = "Work planner",
            //    Description = "Work planner",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var BusinessAnalyst = new Category
            //{
            //    Key = "Business analyst",
            //    Description = "Business analyst",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var DataProtectionOfficer = new Category
            //{
            //    Key = "Data protection officer",
            //    Description = "Data protection officer",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var ManagingDirector = new Category
            //{
            //    Key = "Managing director",
            //    Description = "Managing director",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};

            //var ProjectAssistant = new Category
            //{
            //    Key = "Position assistant",
            //    Description = "Position assistant",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var Purchaser = new Category
            //{
            //    Key = "Purchaser",
            //    Description = "Purchaser",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var QualityManagementRepresentative = new Category
            //{
            //    Key = "Quality management representative",
            //    Description = "Quality management representative",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var SharedServiceCenterSpecialist = new Category
            //{
            //    Key = "Shared service center specialist",
            //    Description = "Shared service center specialist",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};
            //var TechnicalWriter = new Category
            //{
            //    Key = "Technical writer",
            //    Description = "Technical writer",
            //    ParentCategory = InterdisciplinaryRoles,
            //    Industry = itIndustry
            //};

            ////Start->Management IT
            //var ITManager = new Category
            //{
            //    Key = "IT manager",
            //    Description = "IT manager",
            //    ParentCategory = ManagementIT,
            //    Industry = itIndustry
            //};
            //var ServiceLevelManager = new Category
            //{
            //    Key = "Service level manager",
            //    Description = "Service level manager",
            //    ParentCategory = ManagementIT,
            //    Industry = itIndustry
            //};

            ////Start->Network
            //var ConfigurationManager = new Category
            //{
            //    Key = "Configuration manager",
            //    Description = "Configuration manager",
            //    ParentCategory = Network,
            //    Industry = itIndustry
            //};
            //var ITSecurityManager = new Category
            //{
            //    Key = "IT security manager",
            //    Description = "IT security manager",
            //    ParentCategory = Network,
            //    Industry = itIndustry
            //};
            //var NetworkPlanner = new Category
            //{
            //    Key = "Network planner",
            //    Description = "Network planner",
            //    ParentCategory = Network,
            //    Industry = itIndustry
            //};
            //var HeadOfComputerCenter = new Category
            //{
            //    Key = "Head of computer center",
            //    Description = "Head of computer center",
            //    ParentCategory = Network,
            //    Industry = itIndustry
            //};
            //var ITSystemElectronicsTechnician = new Category
            //{
            //    Key = "IT system electronics technician",
            //    Description = "IT system electronics technician",
            //    ParentCategory = Network,
            //    Industry = itIndustry
            //};
            //var SystemIntegrator = new Category
            //{
            //    Key = "System integrator",
            //    Description = "System integrator",
            //    ParentCategory = Network,
            //    Industry = itIndustry
            //};

            ////Start->Quality assurance/Test
            //var ITAuditor = new Category
            //{
            //    Key = "IT auditor",
            //    Description = "IT auditor",
            //    ParentCategory = QualityAssuranceTest,
            //    Industry = itIndustry
            //};
            //var Tester = new Category
            //{
            //    Key = "Tester",
            //    Description = "Tester",
            //    ParentCategory = QualityAssuranceTest,
            //    Industry = itIndustry
            //};
            //var TestManager = new Category
            //{
            //    Key = "Test manager",
            //    Description = "Test manager",
            //    ParentCategory = QualityAssuranceTest,
            //    Industry = itIndustry
            //};

            ////Start->Software development
            //var DatabaseDeveloper = new Category
            //{
            //    Key = "Database developer",
            //    Description = "Database developer",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};
            //var ReleaseManager = new Category
            //{
            //    Key = "Release manager",
            //    Description = "Release manager",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};
            //var SoftwareDeveloper = new Category
            //{
            //    Key = "Software developer",
            //    Description = "Software developer",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};
            //var WebDeveloper = new Category
            //{
            //    Key = "Web developer",
            //    Description = "Web developer",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};
            //var HostDeveloper = new Category
            //{
            //    Key = "Host developer",
            //    Description = "Host developer",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};
            //var SAPDeveloper = new Category
            //{
            //    Key = "SAP developer",
            //    Description = "SAP developer",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};
            //var SystemDeveloper = new Category
            //{
            //    Key = "System developer",
            //    Description = "System developer",
            //    ParentCategory = SoftwareDevelopment,
            //    Industry = itIndustry
            //};

            ////Start->Trainer
            //var ITTrainer = new Category
            //{
            //    Key = "IT trainer",
            //    Description = "IT trainer",
            //    ParentCategory = Trainer,
            //    Industry = itIndustry
            //};

            //new List<Category>
            //    {
            //        AdministrationSupport,
            //        ArchitectureDesign,
            //        BusinessAnalysisConsulting,
            //        InterdisciplinaryRoles,
            //        ManagementIT,
            //        Network,
            //        QualityAssuranceTest,
            //        SoftwareDevelopment,
            //        Trainer,
            //        ApplicationConsultant,
            //        DatabaseAdministrator,
            //        ITOperator,
            //        LinuxAdministrator,
            //        SAPAdministrator,
            //        UnixAdministrator,
            //        WindowsAdministrator,
            //        ApplicationServerAdministrator,
            //        HelpdeskSupport,
            //        ITTechnician,
            //        NetworkAdministrator,
            //        StorageAdministrator,
            //        Webmaster,
            //        CapacityManager,
            //        SystemArchitect,
            //        SoftwareArchitect,
            //        WebDesigner,
            //        BIConsultant,
            //        ChangeManager,
            //        ITConsultant,
            //        SystemAnalyst,
            //        CRMConsultant,
            //        ConsultantForTradingSystems,
            //        SAPConsultant,
            //        Auditor,
            //        BusinessDevelopmentManager,
            //        DirectorBusinessDevelopment,
            //        ProgramManager,
            //        ProjectManager,
            //        QualityAssuranceProfessional,
            //        QualityManager,
            //        SubprojectManager,
            //        WorkPlanner,
            //        BusinessAnalyst,
            //        DataProtectionOfficer,
            //        ManagingDirector,
            //        ProjectAssistant,
            //        Purchaser,
            //        QualityManagementRepresentative,
            //        SharedServiceCenterSpecialist,
            //        TechnicalWriter,
            //        ITManager,
            //        ServiceLevelManager,
            //        ConfigurationManager,
            //        ITSecurityManager,
            //        NetworkPlanner,
            //        HeadOfComputerCenter,
            //        ITSystemElectronicsTechnician,
            //        SystemIntegrator,
            //        ITAuditor,
            //        Tester,
            //        TestManager,
            //        DatabaseDeveloper,
            //        ReleaseManager,
            //        SoftwareDeveloper,
            //        WebDeveloper,
            //        HostDeveloper,
            //        SAPDeveloper,
            //        SystemDeveloper,
            //        ITTrainer
            //    }.ForEach(c => context.Categories.AddOrUpdate(c));


            ////COUNTRY
            //var usa = new Country
            //{
            //    Description = "United States of America",
            //    Key = "UnitedStatesOfAmerica",
            //    ShortName = "USA"
            //};
            //var austria = new Country { Description = "Austria", Key = "Austria", ShortName = "AT" };
            //var france = new Country { Description = "France", Key = "France", ShortName = "FR" };
            //var germany = new Country { Description = "Germany", Key = "Germany", ShortName = "DE" };
            //var hungary = new Country { Description = "Hungary", Key = "Hungary", ShortName = "HU" };
            //var india = new Country { Description = "India", Key = "India", ShortName = "IN" };
            //var italy = new Country { Description = "Italia", Key = "Italia", ShortName = "IT" };
            //var liechtenstein = new Country { Description = "Liechtenstein", Key = "Liechtenstein", ShortName = "LI" };
            //var newZealand = new Country { Description = "New Zealand", Key = "NewZealand", ShortName = "NZ" };
            //var russianFed = new Country
            //{
            //    Description = "Russian Federation",
            //    Key = "RussianFederation",
            //    ShortName = "RU"
            //};
            //var slovakia = new Country { Description = "Slovakia", Key = "Slovakia", ShortName = "SK" };
            //var spain = new Country { Description = "Spain", Key = "Spain", ShortName = "ES" };
            //var switzerland = new Country { Description = "Switzerland", Key = "Switzerland", ShortName = "CH" };
            //var ukraine = new Country { Description = "Ukraine", Key = "Ukraine", ShortName = "UA" };
            //var unitedArabEmirates = new Country
            //{
            //    Description = "United Arab Emirates",
            //    Key = "UnitedArabEmirates",
            //    ShortName = "AE"
            //};
            //var unitedKingdom = new Country { Description = "Austria", Key = "UnitedKingdom", ShortName = "GB" };

            //new List<Country>
            //    {
            //        austria,
            //        france,
            //        germany,
            //        hungary,
            //        india,
            //        italy,
            //        liechtenstein,
            //        newZealand,
            //        russianFed,
            //        slovakia,
            //        spain,
            //        switzerland,
            //        ukraine,
            //        unitedArabEmirates,
            //        unitedKingdom,
            //        usa,
            //    }.ForEach(c => context.Countries.AddOrUpdate(c));


            ////LANGUAGE
            //var arabic = new Language { Description = "Arabic", Key = "Arabic", ShortName = "ar" };
            //var bulgarian = new Language { Description = "Bulgarian", Key = "Bulgarian", ShortName = "bg" };
            //var chinese = new Language { Description = "Chinese", Key = "Chinese", ShortName = "zh" };
            //var czech = new Language { Description = "Czech", Key = "Czech", ShortName = "cz" };
            //var danish = new Language { Description = "Danish", Key = "Danish", ShortName = "da" };
            //var dutch = new Language { Description = "Dutch", Key = "Dutch", ShortName = "nl" };
            //var english = new Language { Description = "English", Key = "English", ShortName = "en" };
            //var finnish = new Language { Description = "Finnish", Key = "Finnish", ShortName = "fi" };
            //var french = new Language { Description = "French", Key = "French", ShortName = "fr" };
            //var german = new Language { Description = "German", Key = "German", ShortName = "de" };
            //var greek = new Language { Description = "Greek", Key = "Greek", ShortName = "el" };
            //var hindi = new Language { Description = "Hindi", Key = "Hindi", ShortName = "hi" };
            //var hungarian = new Language { Description = "Hungarian", Key = "Hungarian", ShortName = "hu" };
            //var italian = new Language { Description = "Italian", Key = "Italian", ShortName = "it" };
            //var japanese = new Language { Description = "Japanese", Key = "Japanese", ShortName = "ja" };
            //var norwegian = new Language { Description = "Norwegian", Key = "Norwegian", ShortName = "no" };
            //var persian = new Language { Description = "Persian", Key = "Persian", ShortName = "fa" };
            //var polish = new Language { Description = "Polish", Key = "Polish", ShortName = "pl" };
            //var portuguese = new Language { Description = "Portuguese", Key = "Portuguese", ShortName = "pt" };
            //var romanian = new Language { Description = "Romanian", Key = "Romanian", ShortName = "ro" };
            //var russian = new Language { Description = "Russian", Key = "Russian", ShortName = "ru" };
            //var swedish = new Language { Description = "Swedish", Key = "Swedish", ShortName = "sv" };
            //var slovak = new Language { Description = "Slovak", Key = "Slovak", ShortName = "sk" };
            //var turkish = new Language { Description = "Turkish", Key = "Turkish", ShortName = "tr" };
            //var ukrainian = new Language { Description = "Ukrainian", Key = "Ukrainian", ShortName = "uk" };

            //new List<Language>
            //    {
            //        arabic,
            //        bulgarian,
            //        chinese,
            //        czech,
            //        danish,
            //        dutch,
            //        english,
            //        finnish,
            //        french,
            //        german,
            //        greek,
            //        hindi,
            //        hungarian,
            //        italian,
            //        japanese,
            //        norwegian,
            //        persian,
            //        polish,
            //        portuguese,
            //        romanian,
            //        russian,
            //        slovak,
            //        swedish,
            //        turkish,
            //        ukrainian
            //    }.ForEach(l => context.Languages.AddOrUpdate(l));


            ////EDUCATION
            //var bachelor = new Education
            //{
            //    Created = "aaa",
            //    Updated = "aaa",
            //    Title = "B.A.",
            //    Key = "Bachelor",
            //    Description = "Bachelor"
            //};
            //var master = new Education
            //{
            //    Created = "aaa",
            //    Updated = "aaa",
            //    Title = "MSc",
            //    Key = "Master",
            //    Description = "Master of Science"
            //};
            //var di = new Education
            //{
            //    Created = "aaa",
            //    Updated = "aaa",
            //    Title = "D.I.",
            //    Key = "Engineer",
            //    Description = "Graduate Engineer"
            //};
            //var phd = new Education { Created = "aaa", Updated = "aaa", Title = "Ph.D", Key = "Doctor", Description = "Doctor" };

            //new List<Education>
            //    {
            //        bachelor,
            //        master,
            //        di,
            //        phd
            //    }.ForEach(e => context.Educations.AddOrUpdate(e));


            ////USER
            //var ExpertProfile1 = new ExpertProfile
            //{
            //    Title = "Viktoria Helm",
            //    Description = "IT Consultant",
            //    Website = "www.sandragorgieva.com",
            //    Skype = "gorgieva_sandra",
            //    Facebook = "Facebook",
            //    Twitter = "Twitter",
            //    Linkedin = "Linkedin",
            //    HourRate = 10,
            //    DailyRate = 100,
            //    MonthlyRate = 1000,
            //    AnnualRate = 10000,
            //    CommentRate = "This is comment for rates",
            //    JobType = 1,
            //    Experience =
            //        "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
            //    References = "This is references",
            //    Availability = "This is availability",
            //    Other = "I have worked for Google and Microsoft",
            //    Location = "91207 Lauf",
            //    AvailabilityStatus = 1,
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "0038970111222",
            //    EducationSkills = new List<EducationSkill> { new EducationSkill { BeginYear = 1997, EndYear = 2003, Program = "Computer Science", University = "University of Vienna, Vienna, Austria", Education = bachelor }, new EducationSkill { BeginYear = 2003, EndYear = 2007, Program = "Arificial Intelligence", University = "University of Vienna, Vienna, Austria", Education = phd } },
            //    CategorySkills = new List<CategorySkill> { new CategorySkill { Category = ITManager, Experience = 3, Level = 2 } },
            //    Country = usa,
            //    Photo = "../../Content/img/250X250_Office-Male-icon.png",
            //    Cv = "Cv_default",
            //    User = user1,
            //    Industry = constructionIndustry
            //};

            //var ExpertProfile2 = new ExpertProfile
            //{
            //    Title = "Roland Mombaur",
            //    Description = "Quality and Process Expert, Writer",
            //    Website = "www.somewebsite.com",
            //    Skype = "Skype",
            //    Facebook = "Facebook",
            //    Twitter = "Twitter",
            //    Linkedin = "Linkedin",
            //    HourRate = 10,
            //    DailyRate = 100,
            //    MonthlyRate = 1000,
            //    AnnualRate = 10000,
            //    CommentRate = "This is comment for rates",
            //    JobType = 0,
            //    Experience =
            //        "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
            //    References = "This is references",
            //    Availability = "This is availability",
            //    Other = "I have experience in electronics",
            //    Location = "91207 Lauf a. d. Pegnitz",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "0038970111222",
            //    AvailabilityStatus = 0,
            //    EducationSkills = new List<EducationSkill> { new EducationSkill { BeginYear = 1997, EndYear = 2003, Program = "Software Engineering", University = "University of Vienna, Vienna, Austria", Education = master }, new EducationSkill { BeginYear = 2003, EndYear = 2007, Program = "Software Architectures", University = "University of Vienna, Vienna, Austria", Education = phd } },
            //    CategorySkills = new List<CategorySkill> { new CategorySkill { Category = DatabaseDeveloper, Experience = 3, Level = 2 } },
            //    Country = germany,
            //    Photo = "../../Content/img/250X250_Office-Male-icon.png",
            //    Cv = "Cv_default",
            //    User = user2,
            //    Industry = constructionIndustry
            //};
            //var ExpertProfile3 = new ExpertProfile
            //{
            //    Title = "Steffen Bangsow",
            //    Description =
            //        "IT Projectmanagement, SAP FI & ERP Customizing, Banking Expert",
            //    Website = "www.web1.com",
            //    Skype = "spaseskype",
            //    Facebook = "Facebook",
            //    Twitter = "Twitter",
            //    Linkedin = "Linkedin",
            //    HourRate = 20,
            //    DailyRate = 200,
            //    MonthlyRate = 2000,
            //    AnnualRate = 20000,
            //    CommentRate = "This is comment for rates",
            //    JobType = 1,
            //    Experience =
            //        "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
            //    References = "This is references",
            //    Availability = "This is availability",
            //    Other = "Microsoft certified",
            //    Location = "91207 Lauf a. d. Pegnitz",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "0038970111222",
            //    AvailabilityStatus = 0,
            //    EducationSkills = new List<EducationSkill> { new EducationSkill { BeginYear = 1997, EndYear = 2003, Program = "Networking Technologies", University = "Technical University, Vienna, Austria", Education = master } },
            //    CategorySkills = new List<CategorySkill> { new CategorySkill { Category = LinuxAdministrator, Experience = 3, Level = 2 } },
            //    Country = austria,
            //    Photo = "../../Content/img/250X250_Office-Male-icon.png",
            //    Cv = "Cv_default",
            //    User = user3,
            //    Industry = itIndustry
            //};

            //var ExpertProfile4 = new ExpertProfile
            //{
            //    Title = "Klaus Rheinwald",
            //    Description =
            //        "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
            //    Website = "www.web2.com",
            //    Skype = "gorgiskype",
            //    Facebook = "Facebook",
            //    Twitter = "Twitter",
            //    Linkedin = "Linkedin",
            //    HourRate = 20,
            //    DailyRate = 200,
            //    MonthlyRate = 2000,
            //    AnnualRate = 20000,
            //    CommentRate = "This is comment for rates",
            //    JobType = 1,
            //    Experience =
            //        "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
            //    References = "This is references",
            //    Availability = "This is availability",
            //    Other = "This is other",
            //    Location = "91207 Lauf a. d. Pegnitz",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "0038970111222",
            //    AvailabilityStatus = 2,
            //    EducationSkills = new List<EducationSkill> { new EducationSkill { BeginYear = 1997, EndYear = 2003, Program = "IT Systems", University = "Univeristy of Technology, Vienna, Austria", Education = bachelor }, new EducationSkill { BeginYear = 2003, EndYear = 2007, Program = "Software Architectures", University = "Univeristy of Technology, Munich, Germany", Education = master } },
            //    CategorySkills = new List<CategorySkill> { new CategorySkill { Category = UnixAdministrator, Experience = 2, Level = 2 } },
            //    Country = italy,
            //    Photo = "../../Content/img/250X250_Office-Male-icon.png",
            //    Cv = "Cv_default",
            //    User = user4,
            //    Industry = itIndustry
            //};
            //var ExpertProfile5 = new ExpertProfile
            //{
            //    Title = "Anna Tomson",
            //    Description =
            //        "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
            //    Website = "www.web2.com",
            //    Skype = "gorgiskype",
            //    Facebook = "Facebook",
            //    Twitter = "Twitter",
            //    Linkedin = "Linkedin",
            //    HourRate = 30,
            //    DailyRate = 300,
            //    MonthlyRate = 3000,
            //    AnnualRate = 30000,
            //    CommentRate = "This is comment for rates",
            //    JobType = 1,
            //    Experience =
            //        "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
            //    References = "This is references",
            //    Availability = "This is availability",
            //    Other = "This is other",
            //    Location = "91207 Lauf a. d. Pegnitz",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "0038970111222",
            //    AvailabilityStatus = 2,
            //    EducationSkills = new List<EducationSkill> { new EducationSkill { BeginYear = 1997, EndYear = 2003, Program = "IT Systems", University = "Univeristy of Technology, Vienna, Austria", Education = bachelor }, new EducationSkill { BeginYear = 2003, EndYear = 2007, Program = "Software Architectures", University = "Univeristy of Technology, Munich, Germany", Education = master } },
            //    CategorySkills = new List<CategorySkill> { new CategorySkill { Category = UnixAdministrator, Experience = 2, Level = 2 } },
            //    Country = italy,
            //    Photo = "../../Content/img/250X250_Office-Male-icon.png",
            //    Cv = "Cv_default",
            //    User = user4,
            //    Industry = creativeIndustry
            //};
            //new List<ExpertProfile>
            //    {
            //        ExpertProfile1,
            //        ExpertProfile2,
            //        ExpertProfile3,
            //        ExpertProfile4,
            //        ExpertProfile5
            //    }.ForEach(p => context.ExpertProfiles.AddOrUpdate(p));

            ////LANGUAGE SKILL
            //var arabicOne = new LanguageSkill { Level = 1, Language = arabic, ExpertProfile = ExpertProfile1 };
            //var arabicTwo = new LanguageSkill { Level = 2, Language = arabic, ExpertProfile = ExpertProfile1 };
            //var arabicThree = new LanguageSkill { Level = 3, Language = arabic, ExpertProfile = ExpertProfile1 };
            //var bulgarianOne = new LanguageSkill { Level = 1, Language = bulgarian, ExpertProfile = ExpertProfile1 };
            //var bulgarianTwo = new LanguageSkill { Level = 2, Language = bulgarian, ExpertProfile = ExpertProfile1 };
            //var bulgarianThree = new LanguageSkill { Level = 3, Language = bulgarian, ExpertProfile = ExpertProfile1 };
            //var chineseOne = new LanguageSkill { Level = 1, Language = chinese, ExpertProfile = ExpertProfile1 };
            //var chineseTwo = new LanguageSkill { Level = 2, Language = chinese, ExpertProfile = ExpertProfile1 };
            //var chineseThree = new LanguageSkill { Level = 3, Language = chinese, ExpertProfile = ExpertProfile1 };
            //var danishOne = new LanguageSkill { Level = 1, Language = danish, ExpertProfile = ExpertProfile1 };
            //var danishTwo = new LanguageSkill { Level = 2, Language = danish, ExpertProfile = ExpertProfile1 };
            //var danishThree = new LanguageSkill { Level = 3, Language = danish, ExpertProfile = ExpertProfile1 };
            //var englishOne = new LanguageSkill { Level = 1, Language = english, ExpertProfile = ExpertProfile1 };
            //var englishTwo = new LanguageSkill { Level = 2, Language = english, ExpertProfile = ExpertProfile1 };
            //var englishThree = new LanguageSkill { Level = 3, Language = english, ExpertProfile = ExpertProfile1 };
            //var finnishOne = new LanguageSkill { Level = 1, Language = finnish, ExpertProfile = ExpertProfile1 };
            //var finnishTwo = new LanguageSkill { Level = 2, Language = finnish, ExpertProfile = ExpertProfile1 };
            //var finnishThree = new LanguageSkill { Level = 3, Language = finnish, ExpertProfile = ExpertProfile1 };
            //var frenchOne = new LanguageSkill { Level = 1, Language = french, ExpertProfile = ExpertProfile1 };
            //var frenchTwo = new LanguageSkill { Level = 2, Language = french, ExpertProfile = ExpertProfile1 };
            //var frenchThree = new LanguageSkill { Level = 3, Language = french, ExpertProfile = ExpertProfile1 };
            //var italianOne = new LanguageSkill { Level = 1, Language = italian, ExpertProfile = ExpertProfile1 };
            //var italianTwo = new LanguageSkill { Level = 2, Language = french, ExpertProfile = ExpertProfile1 };
            //var italianThree = new LanguageSkill { Level = 3, Language = french, ExpertProfile = ExpertProfile1 };
            //var germanOne = new LanguageSkill { Level = 1, Language = german, ExpertProfile = ExpertProfile1 };
            //var germanTwo = new LanguageSkill { Level = 2, Language = german, ExpertProfile = ExpertProfile1 };
            //var germanThree = new LanguageSkill { Level = 3, Language = german, ExpertProfile = ExpertProfile1 };
            //var greekOne = new LanguageSkill { Level = 1, Language = greek, ExpertProfile = ExpertProfile1 };
            //var greekTwo = new LanguageSkill { Level = 2, Language = greek, ExpertProfile = ExpertProfile1 };
            //var greekThree = new LanguageSkill { Level = 3, Language = greek, ExpertProfile = ExpertProfile1 };
            //var hungarianOne = new LanguageSkill { Level = 1, Language = hungarian, ExpertProfile = ExpertProfile1 };
            //var hungarianTwo = new LanguageSkill { Level = 2, Language = hungarian, ExpertProfile = ExpertProfile1 };
            //var hungarianThree = new LanguageSkill { Level = 3, Language = hungarian, ExpertProfile = ExpertProfile1 };
            //var hindiOne = new LanguageSkill { Level = 1, Language = hindi, ExpertProfile = ExpertProfile1 };
            //var hindiTwo = new LanguageSkill { Level = 2, Language = hindi, ExpertProfile = ExpertProfile1 };
            //var hindiThree = new LanguageSkill { Level = 3, Language = hindi, ExpertProfile = ExpertProfile1 };
            //var japaneseOne = new LanguageSkill { Level = 1, Language = japanese, ExpertProfile = ExpertProfile1 };
            //var japaneseTwo = new LanguageSkill { Level = 2, Language = japanese, ExpertProfile = ExpertProfile1 };
            //var japaneseThree = new LanguageSkill { Level = 3, Language = japanese, ExpertProfile = ExpertProfile1 };
            //var dutchOne = new LanguageSkill { Level = 1, Language = dutch, ExpertProfile = ExpertProfile1 };
            //var dutchTwo = new LanguageSkill { Level = 2, Language = dutch, ExpertProfile = ExpertProfile1 };
            //var dutchThree = new LanguageSkill { Level = 3, Language = dutch, ExpertProfile = ExpertProfile1 };
            //var norwegianOne = new LanguageSkill { Level = 1, Language = norwegian, ExpertProfile = ExpertProfile1 };
            //var norwegianTwo = new LanguageSkill { Level = 2, Language = norwegian, ExpertProfile = ExpertProfile1 };
            //var norwegianThree = new LanguageSkill { Level = 3, Language = norwegian, ExpertProfile = ExpertProfile1 };
            //var persianOne = new LanguageSkill { Level = 1, Language = persian, ExpertProfile = ExpertProfile1 };
            //var persianTwo = new LanguageSkill { Level = 2, Language = persian, ExpertProfile = ExpertProfile1 };
            //var persianThree = new LanguageSkill { Level = 3, Language = persian, ExpertProfile = ExpertProfile1 };
            //var polishOne = new LanguageSkill { Level = 1, Language = polish, ExpertProfile = ExpertProfile1 };
            //var polishTwo = new LanguageSkill { Level = 2, Language = polish, ExpertProfile = ExpertProfile1 };
            //var polishThree = new LanguageSkill { Level = 3, Language = polish, ExpertProfile = ExpertProfile1 };
            //var portugueseOne = new LanguageSkill { Level = 1, Language = portuguese, ExpertProfile = ExpertProfile1 };
            //var portugueseTwo = new LanguageSkill { Level = 2, Language = portuguese, ExpertProfile = ExpertProfile1 };
            //var portugueseThree = new LanguageSkill { Level = 3, Language = portuguese, ExpertProfile = ExpertProfile1 };
            //var romanianOne = new LanguageSkill { Level = 1, Language = romanian, ExpertProfile = ExpertProfile4 };
            //var romanianTwo = new LanguageSkill { Level = 2, Language = romanian, ExpertProfile = ExpertProfile1 };
            //var romanianThree = new LanguageSkill { Level = 3, Language = romanian, ExpertProfile = ExpertProfile1 };
            //var russianOne = new LanguageSkill { Level = 1, Language = russian, ExpertProfile = ExpertProfile1 };
            //var russianTwo = new LanguageSkill { Level = 2, Language = russian, ExpertProfile = ExpertProfile1 };
            //var russianThree = new LanguageSkill { Level = 3, Language = russian, ExpertProfile = ExpertProfile1 };
            //var slovakOne = new LanguageSkill { Level = 1, Language = slovak, ExpertProfile = ExpertProfile1 };
            //var slovakTwo = new LanguageSkill { Level = 2, Language = slovak, ExpertProfile = ExpertProfile1 };
            //var slovakThree = new LanguageSkill { Level = 3, Language = slovak, ExpertProfile = ExpertProfile1 };
            //var czechOne = new LanguageSkill { Level = 1, Language = czech, ExpertProfile = ExpertProfile4 };
            //var czechTwo = new LanguageSkill { Level = 2, Language = czech, ExpertProfile = ExpertProfile1 };
            //var czechThree = new LanguageSkill { Level = 3, Language = czech, ExpertProfile = ExpertProfile1 };
            //var turkishOne = new LanguageSkill { Level = 1, Language = turkish, ExpertProfile = ExpertProfile1 };
            //var turkishTwo = new LanguageSkill { Level = 2, Language = turkish, ExpertProfile = ExpertProfile1 };
            //var turkishThree = new LanguageSkill { Level = 3, Language = turkish, ExpertProfile = ExpertProfile1 };
            //var swedishOne = new LanguageSkill { Level = 1, Language = swedish, ExpertProfile = ExpertProfile1 };
            //var swedishTwo = new LanguageSkill { Level = 2, Language = swedish, ExpertProfile = ExpertProfile1 };
            //var swedishThree = new LanguageSkill { Level = 3, Language = swedish, ExpertProfile = ExpertProfile1 };
            //var ukrainianOne = new LanguageSkill { Level = 1, Language = ukrainian, ExpertProfile = ExpertProfile1 };
            //var ukrainianTwo = new LanguageSkill { Level = 2, Language = ukrainian, ExpertProfile = ExpertProfile4 };
            //var ukrainianThree = new LanguageSkill { Level = 3, Language = ukrainian, ExpertProfile = ExpertProfile1 };


            //new List<LanguageSkill>
            //    {
            //        arabicOne,
            //        arabicTwo,
            //        arabicThree,
            //        bulgarianOne,
            //        bulgarianThree,
            //        bulgarianTwo,
            //        chineseOne,
            //        chineseThree,
            //        chineseTwo,
            //        danishOne,
            //        danishThree,
            //        danishTwo,
            //        englishThree,
            //        englishOne,
            //        englishTwo,
            //        finnishOne,
            //        finnishThree,
            //        finnishTwo,
            //        frenchOne,
            //        frenchThree,
            //        frenchTwo,
            //        italianOne,
            //        italianThree,
            //        italianTwo,
            //        germanTwo,
            //        germanOne,
            //        germanThree,
            //        greekOne,
            //        greekThree,
            //        greekTwo,
            //        hungarianOne,
            //        hungarianThree,
            //        hungarianTwo,
            //        hindiOne,
            //        hindiTwo,
            //        hindiThree,
            //        japaneseOne,
            //        japaneseThree,
            //        japaneseTwo,
            //        dutchOne,
            //        dutchThree,
            //        dutchTwo,
            //        norwegianOne,
            //        norwegianThree,
            //        norwegianTwo,
            //        persianTwo,
            //        persianThree,
            //        persianOne,
            //        portugueseOne,
            //        portugueseThree,
            //        portugueseTwo,
            //        polishOne,
            //        polishThree,
            //        polishTwo,
            //        romanianOne,
            //        romanianThree,
            //        romanianTwo,
            //        russianOne,
            //        russianThree,
            //        russianTwo,
            //        slovakTwo,
            //        slovakThree,
            //        slovakOne,
            //        czechOne,
            //        czechThree,
            //        czechTwo,
            //        turkishOne,
            //        turkishThree,
            //        turkishTwo,
            //        swedishTwo,
            //        swedishThree,
            //        swedishOne,
            //        ukrainianOne,
            //        ukrainianThree,
            //        ukrainianTwo
            //    }.ForEach(l => context.LanguageSkills.AddOrUpdate(l));


            ////TECHNOLOGIES
            //var tech1 = new Technology
            //{
            //    Name = "ASP.NET",
            //    Industry = itIndustry
            //};
            //var tech2 = new Technology
            //{
            //    Name = "JAVA",
            //    Industry = itIndustry
            //};
            //var tech3 = new Technology
            //{
            //    Name = "Java Script",
            //    Industry = itIndustry
            //};
            //var tech4 = new Technology
            //{
            //    Name = "PHP",
            //    Industry = itIndustry
            //};
            //var tech5 = new Technology
            //{
            //    Name = "Ruby on Rails",
            //    Industry = itIndustry
            //};

            //new List<Technology>
            //    {
            //        tech1,
            //        tech2,
            //        tech3,
            //        tech4,
            //        tech5
            //    }.ForEach(t => context.Technologies.AddOrUpdate(t));

            ////TECHNOLOGY SKILLS
            ////Asp.Net
            //var aspNetBasic1 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    Level = 1,
            //    Experience = 1,
            //    ExpertProfile = ExpertProfile1
            //};
            //var aspNetBasic2 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 2
            //};
            //var aspNetBasic3 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 3
            //};
            //var aspNetIntermediate1 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 1
            //};
            //var aspNetIntermediate2 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 2
            //};
            //var aspNetIntermediate3 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 3
            //};
            //var aspNetAdvanced1 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 1
            //};
            //var aspNetAdvanced2 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 2
            //};
            //var aspNetAdvanced3 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 3
            //};
            //var aspNetProficient1 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 1
            //};
            //var aspNetProficient2 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 2
            //};
            //var aspNetProficient3 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 3
            //};
            //var aspNetProfessional1 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 1
            //};
            //var aspNetProfessional2 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 2
            //};
            //var aspNetProfessional3 = new TechnologySkill
            //{
            //    Technology = tech1,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 3
            //};

            ////JavaScript
            //var javaScriptBasic1 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 1
            //};
            //var javaScriptBasic2 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 2
            //};
            //var javaScriptBasic3 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 3
            //};
            //var javaScriptIntermediate1 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 1
            //};
            //var javaScriptIntermediate2 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 2
            //};
            //var javaScriptIntermediate3 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 3
            //};
            //var javaScriptAdvanced1 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 1
            //};
            //var javaScriptAdvanced2 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 2
            //};
            //var javaScriptAdvanced3 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 3
            //};
            //var javaScriptProficient1 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 1
            //};
            //var javaScriptProficient2 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 2
            //};
            //var javaScriptProficient3 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 3
            //};
            //var javaScriptProfessional1 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 1
            //};
            //var javaScriptProfessional2 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 2
            //};
            //var javaScriptProfessional3 = new TechnologySkill
            //{
            //    Technology = tech3,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 3
            //};

            ////Java
            //var javaBasic1 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 1
            //};
            //var javaBasic2 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 2
            //};
            //var javaBasic3 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 3
            //};
            //var javaIntermediate1 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile4,
            //    Level = 2,
            //    Experience = 1
            //};
            //var javaIntermediate2 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 2
            //};
            //var javaIntermediate3 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 3
            //};
            //var javaAdvanced1 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 1
            //};
            //var javaAdvanced2 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 2
            //};
            //var javaAdvanced3 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 3
            //};
            //var javaProficient1 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 1
            //};
            //var javaProficient2 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 2
            //};
            //var javaProficient3 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 3
            //};
            //var javaProfessional1 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 1
            //};
            //var javaProfessional2 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 2
            //};
            //var javaProfessional3 = new TechnologySkill
            //{
            //    Technology = tech2,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 3
            //};

            ////Php
            //var phpBasic1 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 1
            //};
            //var phpBasic2 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile4,
            //    Level = 1,
            //    Experience = 2
            //};
            //var phpBasic3 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 3
            //};
            //var phpIntermediate1 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 1
            //};
            //var phpIntermediate2 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 2
            //};
            //var phpIntermediate3 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 3
            //};
            //var phpAdvanced1 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 1
            //};
            //var phpAdvanced2 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 2
            //};
            //var phpAdvanced3 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 3
            //};
            //var phpProficient1 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 1
            //};
            //var phpProficient2 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 2
            //};
            //var phpProficient3 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 3
            //};
            //var phpProfessional1 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 1
            //};
            //var phpProfessional2 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 2
            //};
            //var phpProfessional3 = new TechnologySkill
            //{
            //    Technology = tech4,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 3
            //};

            ////RubyOnRails
            //var rubyBasic1 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 1
            //};
            //var rubyBasic2 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile4,
            //    Level = 1,
            //    Experience = 2
            //};
            //var rubyBasic3 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 1,
            //    Experience = 3
            //};
            //var rubyIntermediate1 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 1
            //};
            //var rubyIntermediate2 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 2
            //};
            //var rubyIntermediate3 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 2,
            //    Experience = 3
            //};
            //var rubyAdvanced1 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 1
            //};
            //var rubyAdvanced2 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 2
            //};
            //var rubyAdvanced3 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 3,
            //    Experience = 3
            //};
            //var rubyProficient1 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 1
            //};
            //var rubyProficient2 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 2
            //};
            //var rubyProficient3 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 4,
            //    Experience = 3
            //};
            //var rubyProfessional1 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 1
            //};
            //var rubyProfessional2 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 2
            //};
            //var rubyProfessional3 = new TechnologySkill
            //{
            //    Technology = tech5,
            //    ExpertProfile = ExpertProfile1,
            //    Level = 5,
            //    Experience = 3
            //};

            //new List<TechnologySkill>
            //    {
            //        aspNetAdvanced1,
            //        aspNetAdvanced2,
            //        aspNetAdvanced3,
            //        aspNetBasic1,
            //        aspNetBasic2,
            //        aspNetBasic3,
            //        aspNetIntermediate1,
            //        aspNetIntermediate2,
            //        aspNetIntermediate3,
            //        aspNetProfessional1,
            //        aspNetProfessional2,
            //        aspNetProfessional3,
            //        aspNetProficient1,
            //        aspNetProficient2,
            //        aspNetProficient3,
            //        javaAdvanced1,
            //        javaAdvanced2,
            //        javaAdvanced3,
            //        javaBasic1,
            //        javaBasic2,
            //        javaBasic3,
            //        javaIntermediate1,
            //        javaIntermediate2,
            //        javaIntermediate3,
            //        javaProfessional1,
            //        javaProfessional2,
            //        javaProfessional3,
            //        javaProficient1,
            //        javaProficient2,
            //        javaProficient3,
            //        javaScriptAdvanced1,
            //        javaScriptAdvanced2,
            //        javaScriptAdvanced3,
            //        javaScriptBasic1,
            //        javaScriptBasic2,
            //        javaScriptBasic3,
            //        javaScriptIntermediate1,
            //        javaScriptIntermediate2,
            //        javaScriptIntermediate3,
            //        javaScriptProfessional1,
            //        javaScriptProfessional2,
            //        javaScriptProfessional3,
            //        javaScriptProficient1,
            //        javaScriptProficient2,
            //        javaScriptProficient3,
            //        phpAdvanced1,
            //        phpAdvanced2,
            //        phpAdvanced3,
            //        phpBasic1,
            //        phpBasic2,
            //        phpBasic3,
            //        phpIntermediate1,
            //        phpIntermediate2,
            //        phpIntermediate3,
            //        phpProfessional1,
            //        phpProfessional2,
            //        phpProfessional3,
            //        phpProficient1,
            //        phpProficient2,
            //        phpProficient3,
            //        rubyAdvanced1,
            //        rubyAdvanced2,
            //        rubyAdvanced3,
            //        rubyBasic1,
            //        rubyBasic2,
            //        rubyBasic3,
            //        rubyIntermediate1,
            //        rubyIntermediate2,
            //        rubyIntermediate3,
            //        rubyProfessional1,
            //        rubyProfessional2,
            //        rubyProfessional3,
            //        rubyProficient1,
            //        rubyProficient2,
            //        rubyProficient3
            //    }.ForEach(ts => context.TechnologySkills.AddOrUpdate(ts));

            ////Positions
            //var project1 = new Position
            //{
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Title = "Desctop application",
            //    Description = "this is app for financials",
            //    StartDate = new DateTime(2012, 10, 25),
            //    Duration = "1 month",
            //    Location = "Brisel,Germany",
            //    JobType = 1,
            //    Categories = new List<Category> { DatabaseAdministrator },
            //    Technologies = new List<Technology> { tech1, tech3 },
            //    Country = austria,
            //    Industry = constructionIndustry
            //};
            //var project2 = new Position
            //{
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Title = "Web application",
            //    Description = "this is app for website",
            //    StartDate = new DateTime(2012, 12, 20),
            //    Duration = "1 month",
            //    Location = "Milano,Italy",
            //    JobType = 1,
            //    Categories = new List<Category> { UnixAdministrator },
            //    Technologies = new List<Technology> { tech5 },
            //    Country = germany,
            //    Industry = constructionIndustry
            //};
            //var project3 = new Position
            //{
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Title = "Android application",
            //    Description = "this is android appliaction",
            //    StartDate = new DateTime(2012, 10, 25),
            //    Duration = "2 months",
            //    Location = "Washington,USA",
            //    JobType = 1,
            //    Categories = new List<Category> { WindowsAdministrator },
            //    Technologies = new List<Technology> { tech4, tech3 },
            //    Country = india,
            //    Industry = creativeIndustry
            //};
            //var project4 = new Position
            //{
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Title = "Desctop application",
            //    Description = "this is app for financials",
            //    StartDate = new DateTime(2012, 10, 25),
            //    Duration = "1 month",
            //    Location = "Germany",
            //    JobType = 1,
            //    Categories = new List<Category> { Tester },
            //    Technologies = new List<Technology> { tech2 },
            //    Country = usa,
            //    Industry = creativeIndustry
            //};
            //var project5 = new Position
            //{
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Title = "Web site for bank",
            //    Description = "this is  web site for financials",
            //    StartDate = new DateTime(2012, 10, 25),
            //    Duration = "3 month",
            //    Location = "Italy",
            //    JobType = 1,
            //    Categories = new List<Category> { SystemDeveloper },
            //    Technologies = new List<Technology> { tech2 },
            //    Country = unitedArabEmirates,
            //    Industry = itIndustry
            //};
            //var project6 = new Position
            //{
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Title = "Desctop application",
            //    Description = "this is app for financials",
            //    StartDate = new DateTime(2012, 10, 25),
            //    Duration = "1 month",
            //    Location = "Brisel,Germany",
            //    JobType = 0,
            //    Categories = new List<Category> { ITConsultant },
            //    Technologies = new List<Technology> { tech1, tech3 },
            //    Country = slovakia,
            //    Industry = itIndustry
            //};

            //new List<Position>
            //    {
            //        project1,
            //        project2,
            //        project3,
            //        project4,
            //        project5,
            //        project6
            //    }.ForEach(p => context.Positions.AddOrUpdate(p));


            ////COMPANY PROFILES
            //var companyProfile1 = new CompanyProfile
            //{
            //    Title = "Software Design",
            //    TagLine = "tag",
            //    Description = "We design software solutions",
            //    Website = "http://www.softwaredesign.com",
            //    Location = " Street nn Rome,Italy",
            //    Photo = "../../Content/img/250X250_company_icon.png",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "00389070333555",
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Positions = new List<Position> { project1, project2 },
            //    User = user1,
            //    Country = unitedArabEmirates,
            //    Industry = constructionIndustry
            //};
            //var companyProfile2 = new CompanyProfile
            //{
            //    Title = "Database Administrations",
            //    TagLine = "tag",
            //    Description = "We are DB administrators",
            //    Website = "http://www.db.com",
            //    Location = "Street 55, Berlin,Germany",
            //    Photo = "../../Content/img/250X250_company_icon.png",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "00389070333555",
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Positions = new List<Position> { project3, project4 },
            //    User = user2,
            //    Country = usa,
            //    Industry = itIndustry
            //};
            //var companyProfile3 = new CompanyProfile
            //{
            //    Title = "Networks",
            //    TagLine = "tag",
            //    Description = "All about networks",
            //    Website = "http://www.networksforyou.com",
            //    Location = " Street 66 NY,USA",
            //    Photo = "../../Content/img/250X250_company_icon.png",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "00389070333555",
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Positions = new List<Position> { project5 },
            //    User = user3,
            //    Country = austria,
            //    Industry = itIndustry
            //};
            //var companyProfile4 = new CompanyProfile
            //{
            //    Title = "Web Design",
            //    TagLine = "tag",
            //    Description = "It's all about the web",
            //    Website = "http://www.webwebweb.com",
            //    Location = " Street 77 Paris,France",
            //    Photo = "../../Content/img/250X250_company_icon.png",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "00389070333555",
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Positions = new List<Position> { project6 },
            //    User = user4,
            //    Country = germany,
            //    Industry = creativeIndustry
            //};
            //var companyProfile5 = new CompanyProfile
            //{
            //    Title = "Company 5",
            //    TagLine = "tag",
            //    Description = "It's all about the web",
            //    Website = "http://www.webwebweb.com",
            //    Location = " Street 77 Paris,France",
            //    Photo = "../../Content/img/250X250_company_icon.png",
            //    Email = "gorgieva_sandra@yahoo.com",
            //    PhoneNumber = "00389070333555",
            //    Updated = "aaa",
            //    Created = "aaa",
            //    Positions = new List<Position> { project6 },
            //    User = user4,
            //    Country = germany,
            //    Industry = creativeIndustry
            //};

            //new List<CompanyProfile>
            //    {
            //        companyProfile1,
            //        companyProfile2,
            //        companyProfile3,
            //        companyProfile4,
            //        companyProfile5
            //    }.ForEach(c => context.CompanyProfiles.AddOrUpdate(c));


            //context.SaveChanges();

            base.Seed(context);
        }
    }
}